<!-- Restaurant Control Program >> Restaurant Manager  --> 


<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>

<%-- set data source --%>
<c:if test="${empty sessionScope.connection}">
	<sql:setDataSource
		driver="com.mysql.jdbc.Driver"
		url="jdbc:mysql://localhost:3306/" 
		user="root"
		password="sesame"
		scope="session"
	/>
</c:if>

<html>

	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
		<title>Staff Manager</title>
		<link href="resources/CSS/LobbyTemplate.css" rel="stylesheet" type="text/css"/>
	</head>
	
	<body>
	
	daesfged
		
		<sql:query var="results" sql="SELECT EmployeeID, firstname, lastname FROM employees;"/>
	
		<table>
		
			<c:forEach items="${results.rows}" var="row">
			
				<tr>
			
					<c:forEach items="${row}" var="col">
					
						<td>
							
							${col.value}
							
						</td>
					
					</c:forEach>
				
				</tr>
			
			</c:forEach>
			
		</table>
	
	</body>
	
</html>